package xin.baizhiedu.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.io.Serializable;

/**
 * SELECT
 * 	B.JOB_NAME,
 * 	A.JOB_CODE,
 * 	B.JOB_CODE AS JOB_ASE,
 * 	B.STUT_STATENAME,
 * 	B.MATE_CODE,
 * 	B.ABNORMAL_FLAG,
 * 	b.JOB_EQNAME,
 * 	A.MATE_SERIALNUMBER,
 * 	A.TEAM_NAME
 * FROM
 * 	(
 * 	SELECT
 * 		JOB_ID,
 * 		JOB_NAME,
 * 		JOB_CODE,
 * 		MATE_SERIALNUMBER,
 * 		TEAM_NAME
 * 	FROM
 * 		T_PLAN_JOB
 * 	WHERE
 * 		STUT_STATECODE = 'PLAN.t_plan_Job.STUT_StateCode.014'
 * 		AND JOB_TYPENAME = '订单'
 * 		AND JOB_DIVISION = '1'
 * 		AND TEAM_NAME IS NOT NULL
 * 	) A,
 * 	T_PLAN_JOB B
 * WHERE
 * 	A.JOB_ID = B.JOB_PID
 */
@Data
@TableName(value = "QG_JOB_ORDER_WORKING", autoResultMap = true)
public class qgJobOrderWorking  implements Serializable {

    private static final long serialVersionUID = 1L;
    /**
     * 工序名称
     */
    @TableField(value = "JOB_NAME")
    private String jobName;

    /**
     * 工序状态
     */
    @TableField(value = "STUT_STATENAME")
    private String stutStatename;

    /**
     * 物料名称
     */
    @TableField(value = "MATE_CODE")
    private String mateCode;

    /**
     * 物料名称
     */
    @TableField(value = "JOB_ASE")
    private String jobAse;


    /**
     * 是否异常 （1是）
     */
    @TableField(value = "ABNORMAL_FLAG")
    private String abnormalFlag;

    /**
     * 工位名称
     */
    @TableField(value = "JOB_EQNAME")
    private String jobEqname;


    /**
     * 工单号
     */
    @TableField(value = "JOB_CODE")
    private String jobCode;

    /**
     * SN码
     */
    @TableField(value = "MATE_SERIALNUMBER")
    private String mateSerialnumber;

    /**
     * 产线
     */
    @TableField(value = "TEAM_NAME")
    private String teamName;


    /**
     * 工位类别
     */
    @TableField(value = "MANU_TYPE")
    private String manuType;

}
